
--This script can be used to delete and re-setup the marriage document fields for each marriage document type.

DECLARE @DocumentTypeId as integer

This sytax error is here to remind you to setup the document types first and to change it for each document type in the marriage group.
--Set up all marriage related document types, then run this script for each type after changing the select statement below.
Select  @DocumentTypeId = [Id] from [DocumentType] where  [Code] = 'MarriageKiosk'

delete from DocumentTypeField where documenttypeid = @DocumentTypeId

INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BitField1', 'Party One Ever Married', NULL, 135, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:02:32:907', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BitField2', 'Party Two Ever Married', NULL, 325, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:02:46:157', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'ComboField2', 'Party One Marriage Ended', '{ComboList}| |High Expectations|Adultery|Compatibility||Low Tolerance|Dowry and Harassment|Lack of Commitment|Lack of Physical Attraction|Family Pressures|Lack of Communication|Family Background', NULL, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:51:06:323', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'ComboField4', 'Party Two Marriage Ended', '{ComboList}|High Expectations|Adultery|Compatibility|Low Tolerance|Dowry and Harassment|Lack of Commitment|Lack of Physical Attraction|Family Pressures|Lack of Communication|Family Background', 355, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:05:00:967', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField1', 'Party One Date of Birth', NULL, 115, 0, 0, 1, 1, '20130910 00:00:00:000', 113, '20150106 11:00:25:950', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField2', 'Party Two Date of Birth', NULL, 30, 0, 0, 1, 1, '20130910 00:00:00:000', 113, '20150106 11:01:16:003', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField3', 'Party One Date License Effect', NULL, 40, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:50:23:830', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField4', 'Expiration Date', NULL, 45, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:03:00:787', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField5', 'Party One Marriage Date', NULL, 10, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:50:26:423', NULL, 0, '', '', '', '**/**/****', '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField1', 'One First Name ', NULL, 55, 0, 1, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:45:12:933', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField10', 'Party Two Last Name', NULL, 255, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 10:59:23:153', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField2', 'Party Two Given Name', NULL, 310, 0, 0, 0, 1, '20130910 00:00:00:000', 164, '20150204 14:09:38:230', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField3', 'Party Two City', NULL, 275, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 10:55:21:633', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField4', 'Party Two County', NULL, 290, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 10:55:26:747', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField5', 'Party Two State', NULL, 280, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 10:55:31:113', NULL, 0, '', '', '', NULL, 'STATES', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField6', 'Party Two Birth State', NULL, 320, 0, 0, 1, 1, '20130910 00:00:00:000', 113, '20150106 10:55:35:550', NULL, 0, '', '', '', NULL, 'STATES', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField7', 'Party One SSN', NULL, 105, 0, 0, 1, 1, '20130910 00:00:00:000', 75, '20150327 16:50:45:897', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField8', 'Party One Marriages', NULL, 145, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:51:01:883', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField9', 'Party Two SSN', NULL, 300, 0, 0, 1, 1, '20130910 00:00:00:000', 113, '20150106 11:06:13:887', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField11', 'Party Two Marriages', NULL, 340, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:05:31:253', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField12', 'One Middle Name', NULL, 60, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:46:17:813', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField13', 'One Last Name', NULL, 65, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:46:07:300', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField14', 'Party One County', NULL, NULL, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:50:29:227', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField15', 'Party One Street Address', NULL, 80, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:50:32:183', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField16', 'Party One State', NULL, 90, 0, 0, 0, 1, '20130910 00:00:00:000', 75, '20150327 16:50:37:490', NULL, 0, '', '', '', NULL, 'STATES', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField17', 'Party One Birth State', NULL, 125, 0, 0, 1, 1, '20130910 00:00:00:000', 75, '20150327 16:50:41:853', NULL, 0, '', '', '', NULL, 'STATES', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField18', 'Party Two First Name', NULL, 245, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:06:20:387', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField19', 'Party Two Middle Name', NULL, 250, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:06:31:300', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField20', 'Party One Suffix Name', NULL, 70, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:07:36:607', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField21', 'Party One City', NULL, 85, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:05:59:983', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField22', 'Party Two Street Address', NULL, 270, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:05:51:470', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField23', 'Party One Zip Code', NULL, 95, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:07:50:450', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField24', 'Party One Phone', NULL, 110, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:07:23:397', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField6', 'Party One Last Marriage Ended Date', NULL, 150, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:03:18:593', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField26', 'Party Two Zip Code', NULL, 285, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:06:42:173', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField27', 'Party Two Phone', NULL, 305, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:06:37:443', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'DateField7', 'Party Two Last Marriage Ended Date', NULL, 345, 0, 0, 0, 1, '20130910 00:00:00:000', 113, '20150106 11:06:26:103', NULL, 0, '', '', '', NULL, '', 0, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField28', 'One Given Name', NULL, 75, 0, 0, 0, 2, '20150102 12:10:07:300', 75, '20150327 16:45:55:573', 0, NULL, '', NULL, NULL, NULL, NULL, 0, 0)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'TextField29', 'Party Two Suffix Name', NULL, 260, 0, 0, 0, 2, '20150102 13:22:14:493', 75, '20150327 16:51:10:587', 0, NULL, '', NULL, NULL, NULL, NULL, 0, 0)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'ApplyingForMaritalStatusOf', 'Applying For Marital Status Of', NULL, 15, 0, 0, 0, 0, '20150328 12:41:50:990', 0, '20150328 12:41:50:990', NULL, 0, 'Solicitar el estatus Marital de', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BloodRelated', 'Blood Related?', NULL, 20, 0, 0, 0, 0, '20150328 12:41:51:003', 0, '20150328 12:41:51:003', NULL, 0, 'Relacion Sanguinea', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BloodRelatedDescription', 'Blood Related Description', NULL, 25, 0, 0, 0, 0, '20150328 12:41:51:013', 0, '20150328 12:41:51:013', NULL, 0, 'Descripcion de la Relacion Sanguinea', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'CeremonyType', 'Ceremony Type', '{ComboList}|Religious|Civil|Self', 5, 0, 0, 0, 0, '20150328 12:41:51:020', 0, '20150328 12:41:51:020', NULL, 0, 'Tipo de Ceremonia', NULL, NULL, '', '{ComboList}|Religious|Civil|Self', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomBirthCity', '[G] Birth City', NULL, 35, 0, 0, 0, 0, '20150328 12:41:51:030', 0, '20150328 12:41:51:030', NULL, 0, 'ciudad de nacimiento', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideBirthCity', '[B]  Birth City', NULL, 315, 0, 0, 0, 0, '20150328 12:41:51:040', 0, '20150328 12:41:51:040', NULL, 0, 'ciudad de nacimiento', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianRequired', '[G] Guardian required on ceremony day?', NULL, 175, 0, 0, 0, 0, '20150328 12:41:51:047', 0, '20150328 12:41:51:047', NULL, 0, 'The guardian en ceremonia da?', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianRequired', '[B] Guardian required on ceremony day?', NULL, 375, 0, 0, 0, 0, '20150328 12:41:51:053', 0, '20150328 12:41:51:053', NULL, 0, 'The guardian en ceremonia da?', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianFatherFirstName', '[GF] Guardian First', NULL, 180, 0, 0, 0, 0, '20150328 12:41:51:063', 0, '20150328 12:41:51:063', NULL, 0, 'Primer Nombre del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianFatherMiddleName', '[GF] Guardian Middle', NULL, 185, 0, 0, 0, 0, '20150328 12:41:51:070', 0, '20150328 12:41:51:070', NULL, 0, 'Segundo Nombre del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianFatherLastName', '[GF] Guardian Last', NULL, 190, 0, 0, 0, 0, '20150328 12:41:51:080', 0, '20150328 12:41:51:080', NULL, 0, ', Apellidos del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianFatherCity', '[GF] Guardian City', NULL, 195, 0, 0, 0, 0, '20150328 12:41:51:090', 0, '20150328 12:41:51:090', NULL, 0, 'Ciudad del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianFatherState', '[GF] Guardian State', NULL, 200, 0, 0, 0, 0, '20150328 12:41:51:097', 0, '20150328 12:41:51:097', NULL, 0, 'Estado del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianFatherFirstName', '[BF] Guardian First', NULL, 380, 0, 0, 0, 0, '20150328 12:41:51:107', 0, '20150328 12:41:51:107', NULL, 0, 'Primer Nombre del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianFatherMiddleName', '[BF] Guardian Middle', NULL, 385, 0, 0, 0, 0, '20150328 12:41:51:113', 0, '20150328 12:41:51:113', NULL, 0, 'Segundo Nombre del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianFatherLastName', '[BF] Guardian Last', NULL, 42, 0, 0, 0, 0, '20150328 12:41:51:120', 0, '20150328 12:41:51:120', NULL, 0, ', Apellidos del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianFatherCity', '[BF] Guardian City', NULL, 390, 0, 0, 0, 0, '20150328 12:41:51:130', 0, '20150328 12:41:51:130', NULL, 0, 'Ciudad del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianFatherState', '[BF] Guardian State', NULL, 395, 0, 0, 0, 0, '20150328 12:41:51:140', 0, '20150328 12:41:51:140', NULL, 0, 'Estado del Padre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianMotherFirstName', '[GM] Guardian Mother First', NULL, 205, 0, 0, 0, 0, '20150328 12:41:51:147', 0, '20150328 12:41:51:147', NULL, 0, 'Primer Nombre del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianMotherMiddleName', '[GM] Guardian Middle', NULL, 210, 0, 0, 0, 0, '20150328 12:41:51:153', 0, '20150328 12:41:51:153', NULL, 0, 'Segundo Nombre del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianMotherLastName', '[GM] Guardian Last', NULL, 215, 0, 0, 0, 0, '20150328 12:41:51:163', 0, '20150328 12:41:51:163', NULL, 0, ', Apellidos del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianMotherCity', '[GM] Guardian City', NULL, 220, 0, 0, 0, 0, '20150328 12:41:51:170', 0, '20150328 12:41:51:170', NULL, 0, 'Ciudad del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGuardianMotherState', '[GM] Guardian State', NULL, 225, 0, 0, 0, 0, '20150328 12:41:51:180', 0, '20150328 12:41:51:180', NULL, 0, 'Estado del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianMotherFirstName', '[BM] Guardian First', NULL, 400, 0, 0, 0, 0, '20150328 12:41:51:190', 0, '20150328 12:41:51:190', NULL, 0, 'Primer Nombre del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianMotherMiddleName', '[BM] Guardian Middle', NULL, 405, 0, 0, 0, 0, '20150328 12:41:51:197', 0, '20150328 12:41:51:197', NULL, 0, 'Segundo Nombre del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianMotherLastName', '[BM] Guardian Last', NULL, 50, 0, 0, 0, 0, '20150328 12:41:51:203', 0, '20150328 12:41:51:203', NULL, 0, ', Apellidos del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianMotherCity', '[BM] Guardian City', NULL, 410, 0, 0, 0, 0, '20150328 12:41:51:213', 0, '20150328 12:41:51:213', NULL, 0, 'Ciudad del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGuardianMotherState', '[BM] Guardian State', NULL, 415, 0, 0, 0, 0, '20150328 12:41:51:220', 0, '20150328 12:41:51:220', NULL, 0, 'Estado del Madre', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomPresentMaritalStatus', '[G] Marital Status', '{ComboList}|Single|Widowed|Divorced/Dissolved|Married|Civil Union', 35, 0, 0, 0, 0, '20150328 12:41:51:230', 0, '20150328 12:41:51:230', NULL, 0, 'Estado Civil Actual ', NULL, NULL, '', '{ComboList}|Single|Widowed|Divorced/Dissolved|Married|Civil Union', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BridePresentMaritalStatus', '[B] Marital Status', '{ComboList}|Single|Widowed|Divorced/Dissolved|Married|Civil Union', 240, 0, 0, 0, 0, '20150328 12:41:51:240', 0, '20150328 12:41:51:240', NULL, 0, 'Estado Civil Actual ', NULL, NULL, '', '{ComboList}|Single|Widowed|Divorced/Dissolved|Married|Civil Union', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomProofOfAge', '[G] Proof of Age', '{ComboList}|Valid Drivers License|Passport|Birth Certificate|Other (specify)', 130, 0, 0, 0, 0, '20150328 12:41:51:247', 0, '20150328 12:41:51:247', NULL, 0, 'Prueba de Edad', NULL, NULL, '', '{ComboList}|Valid Drivers License|Passport|Birth Certificate|Other (specify)', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideProofOfAge', '[B] Proof of Age', '{ComboList}|Valid Drivers License|Passport|Birth Certificate|Other (specify)', 330, 0, 0, 0, 0, '20150328 12:41:51:257', 0, '20150328 12:41:51:257', NULL, 0, 'Prueba de Edad', NULL, NULL, '', '{ComboList}|Valid Drivers License|Passport|Birth Certificate|Other (specify)', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomPreviousMarriedName', '[G] Previous Married Name', NULL, 140, 0, 0, 0, 0, '20150328 12:41:51:263', 0, '20150328 12:41:51:263', NULL, 0, 'Nombres anteriores ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BridePreviousMarriedName', '[B] Previous Married Name', NULL, 335, 0, 0, 0, 0, '20150328 12:41:51:270', 0, '20150328 12:41:51:270', NULL, 0, 'Nombres anteriores ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomGender', '[G] Gender', '{ComboList}|Female|Male', 50, 0, 0, 0, 0, '20150328 12:41:51:280', 0, '20150328 12:41:51:280', NULL, 0, 'Genero', NULL, NULL, '', '{ComboList}|Female|Male', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideGender', '[B] Gender', '{ComboList}|Female|Male', 235, 0, 0, 0, 0, '20150328 12:41:51:290', 0, '20150328 12:41:51:290', NULL, 0, 'Genero', NULL, NULL, '', '{ComboList}|Female|Male', NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomDivorcedWidowedDate', '[G] Divorced/Widowed Date', NULL, 155, 0, 0, 0, 0, '20150328 12:41:51:297', 0, '20150328 12:41:51:297', NULL, 0, 'Fecha de Divorciado, Viudo ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomDivorcedWidowedCity', '[G] Divorced/Widowed City', NULL, 62, 0, 0, 0, 0, '20150328 12:41:51:307', 0, '20150328 12:41:51:307', NULL, 0, 'Cuidad del Divorcio ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomDivorcedWidowedState', '[G] Divorced/Widowed State', NULL, 165, 0, 0, 0, 0, '20150328 12:41:51:313', 0, '20150328 12:41:51:313', NULL, 0, 'Estado del Divorcio ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomDivorcedWidowedTypeOfCourt', '[G] Divorced/Widowed Court', NULL, 170, 0, 0, 0, 0, '20150328 12:41:51:320', 0, '20150328 12:41:51:320', NULL, 0, 'Tipo de Corte del Divorcio ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideDivorcedWidowedDate', '[B] Divorced/Widowed Date', NULL, 350, 0, 0, 0, 0, '20150328 12:41:51:330', 0, '20150328 12:41:51:330', NULL, 0, 'Fecha de Divorciado, Viudo ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideDivorcedWidowedCity', '[B] Divorced/Widowed City', NULL, 66, 0, 0, 0, 0, '20150328 12:41:51:340', 0, '20150328 12:41:51:340', NULL, 0, 'Cuidad del Divorcio ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideDivorcedWidowedState', '[B] Divorced/Widowed State', NULL, 365, 0, 0, 0, 0, '20150328 12:41:51:347', 0, '20150328 12:41:51:347', NULL, 0, 'Estado del Divorcio ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideDivorcedWidowedTypeOfCourt', '[B] Divorced/Widowed Court', NULL, 370, 0, 0, 0, 0, '20150328 12:41:51:357', 0, '20150328 12:41:51:357', NULL, 0, 'Tipo de Corte del Divorcio ', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'GroomAllLegalNamesOtherThanBirthOrCurrent', '[G] All Legal Names Other Than Birth and Current', NULL, 230, 0, 0, 0, 0, '20150328 12:41:51:363', 0, '20150328 12:41:51:363', NULL, 0, 'Todos los nombres legales sin contar el de nacimi', NULL, NULL, '', NULL, NULL, NULL)
INSERT dbo.DocumentTypeField (DocumentTypeId, FieldName, Prompt, DefaultValue, DisplayOrder, RequiredForRecording, RequiredForIndexing, HideFromSearch, CreateByUserId, CreateDate, ModifyByUserId, ModifyDate, BlindKeyVerify, LegalGroup, SpanishPrompt, EnglishPromptHelper, SpanishPromptHelper, FormatMask, ComboList, LimitToComboList, LegalRange) VALUES (@DocumentTypeId, 'BrideAllLegalNamesOtherThanBirthOrCurrent', '[B] All Legal Names Other Than Birth and Current', NULL, 420, 0, 0, 0, 0, '20150328 12:41:51:370', 0, '20150328 12:41:51:370', NULL, 0, 'Todos los nombres legales sin contar el de nacimi', NULL, NULL, '', NULL, NULL, NULL)
